Nic Larsen ✭✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	41

About Me

About Me

Not much happening here, yet.

Analytics

527

Posts

2,462

Visits

11.4k

Points

Jun 26, 2018

Join Date

Mar 7, 2025

Last Active

Reactions

• Insightful 11

  11
• Vote Up 30

  30
• Awesome 57

  57

• Activity
• Discussions2
• Comments525

• Re: Using a COUNTIF but need two criteria

  Nic Larsen

  09/17/24
  You just need to change the COUNTIF to COUNTIFS and add your 2nd range and 2nd criteria =COUNTIFS({Project List Range 1}, Labels@row, Range2, Criteria2
  1 ·

• Re: IF formula help resquested !

  Nic Larsen

  09/04/24
  Should be: =IF(FREQUENCE@row = "Probable FREQUENT"; 5; IF(FREQUENCE@row = "Probable MENSUEL"; 4; IF(FREQUENCE@row = "Probable ANNUEL"; 3; IF(FREQUENCE@row = "RARE&q…
  1 ·

• Re: What view are you? Share your story and claim your badge

  Nic Larsen

  08/01/24
  Grid View - I like to be able to see as much as possible without other clutter.
  1 ·

• Re: COUNTIFS issue

  Nic Larsen

  08/06/24
  Try using it with a CONTAINS function, similar to this below: =COUNTIFS(Position:Position, CONTAINS("Parish Center", @cell)
  1 ·

• Re: Please help with Formuala

  Nic Larsen

  08/07/24
  Okay - I better understand what you're trying to do. It's almost an IF(AND with 2 true statements (with an OR) and then a COUNT or COUNTM to count number of replies… I can visualize it, but getting i…
  1 ·

Previous Next